Evaluating multiple join queries in a distributed database system
نویسندگان
چکیده
منابع مشابه
Analysis of a DSS Queries in a Distributed Database System
Parallel processing is a technique of executing the multiple tasks concurrently on different processors. Parallel processing helps in solving all the intricate problems that require immense processing time in an optimized way. In case of parallel processing one of the major issues is the scheduling of different tasks on different processors that can be performed in either static list scheduling...
متن کاملO~WvIlZlNG STAR QUERIES IN A DISTRIBUTED DATABASE SYSTEM’
The problem of optimal query processing in distributed database systems was shown to be NPhard. However, for a special type of queries called star queries, we have developed a polynomial optimal algorithm. In an earlier paper, we described an approach to obtain the optimal semi-join program for a star query by gradually reducing the search space to a minimal set S without making any assumptions...
متن کاملOptimization of Queries in Distributed Database Management System
The query optimizer is widely considered to be the most important component of a database management system. it is a process of producing an optimal (close to optimal) query execution plan which represents an execution strategy for the query. It is responsible for taking a user query and searching through the entire space of equivalent execution plans for a given user query and returning the ex...
متن کاملEvaluating Join Performance on Relational Database Systems
The join operator is fundamental in relational database systems. Evaluating join queries on large tables is challenging because records need to be efficiently matched based on a given key. In this work, we analyze join queries in SQL with large tables in which a foreign key may be null, invalid or valid, given a referential integrity constraint. We conduct an extensive join performance evaluati...
متن کاملAn Optimal Evaluation of GroupBy-Join Queries in Distributed Architectures
aPDBMS : Parallel Database Management Systems. Abstract: SQL queries involving join and group-by operations are fairly common in many decision support applications where the size of the input relations is usually very large, so the parallelization of these queries is highly recommended in order to obtain a desirable response time. Several parallel algorithms that treat this kind of queries have...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Mathematical and Computer Modelling
سال: 1995
ISSN: 0895-7177
DOI: 10.1016/0895-7177(95)00033-x